The SQL Data Compare API Submit feedback on this topic   
Frequently Asked Questions for the SQL Data Compare API

Glossary Item Box


How can I choose individual records to synchronize?

Create a new SelectionDelegate and point it at a function that will return true or false, indicating whether the record is to be synchronized. This function will accept a SynchronizationRecord object as the only argument. Pass the SelectionDelegate as the second argument to the GetMigrationSQL method of the SqlProvider object.


How do I change the comparison key?

When you have a TableMapping object, you can use the MatchingMappings property or the UseIndexForMapping method to specify the fields to use for the comparison key.


How do I change the options such as disabling Foreign Keys and Triggers?

Specify the options on the SqlProvider.Options property from the SqlOptions enumeration.


Do I have to distribute my license file with my application?

No. A properly compiled SQL Data Compare API application will not request a serial number when it is distributed.


How do I install my application on the client?

Copy your application and the assemblies it references to the same folder (or the Global Assembly Cache - not recommended). No registration or registry entries are required unless specifically requested by your application.

 

See Also

Getting Started with the SQL Data Compare API

Introduction to the API Reference